Best ERwin tutorial on udemy

To get good hands on ERwin you can go through this training in UdemyERwin Training

Talend Detailed Error : syntax error on these tokens ,delete these tokens on snowflake query

When we have double quotes in the input SQL query we generally get this error , to by pass the error we need to use escape character "\"  before double quotes. And it's mostly helpful in case of snowflake manual queries

Ever faced issue with capslock printing small letters instead of capital letters

Some times we notice after turning on caps lock you see small letters getting printed and capital letters when capslock is turned off . It's may be because you might have accidentally turned on sticky keys. To resolve this issue press both shift keys (right and left) at a time on your keyboard, that should resolve the issue.

Undo sent mail in your gmail

If you make a typo or regret sending a message, you can undo the action by enabling "Undo send." This setting gives you the option to take back a message you just sent.

To enable Undo Send:

1. Click the gear in the top right .
2. Select Settings.
3. Scroll down to "Undo Send" and click Enable.
4. Set the cancellation period (the amount of time you have to decide if you want to unsend an email).
5. Click Save Changes at the bottom of the page.
6. If you had Undo Send turned on in Gmail Labs, your Undo Send setting will be on by default.
7. To test the feature, click the Compose button at the upper left corner of your Gmail account page.
8. Compose a message and then click the Send button.
9. At the top of the screen, you'll see a message that says: "Your message has been sent. Undo. View Message."
10. To prevent the message from being sent, click the Undo link.
11. Gmail stops the message from going out and displays it in case you wish to make any changes and then resend it. If not, you can simply close the message, and it's relegated to your Drafts folder where you can keep it or delete it.

Note: To give you time to undo, Gmail delays sending the message for a few seconds. So if you don't select "Undo" within the time limit, your message will be sent. "Undo send" may not work if you experience connection issues.

SSIS interview Questions

Explain Different types of Slowly changing dimensions?

Difference between merge and merge join?

Difference between union and union all?

How to deploy SSIS packages?

Different methods for performance tuning of SSIS packages?

Difference between lookup and merge in SSIS?

Problems you faced while executing SSIS packages?

How to run a package based on the output of 'Execute Sql task'? The output of the SQl task is binary (either 1 or 0) You need to run package if the output is 1 and disable the package if the output is 0

What are the different steps in data warehouse life cycle?

What are different types of data sources you used in your project?

What is the difference between control flow task and data flow task?

Explain the methods to send a mail in SSIS?

How to store a sentence in python?

Worring about how to store a sentence in python?

s="""Python is a widely used general-purpose, high-level programming language.[17][18][19] Its design philosophy emphasizes code readability, and its syntax allows programmers to express concepts in fewer lines of code than would be possible in languages such as C++ or Java."""
print s

CALCULATION OF XIRR

How do you calculate your returns when you every year you invest different amount and at the end you receive your Money back? Suppose your invest 1000, 1000, 2000, 2000 and 3000 in 5 yrs and Get 11,000 at the end of 5 yrs then what is your Return? It’s 8%. The concept is called IRR.


WHAT IS IRR?


IRR is Internal Rate of Return and it is used to calculate the returns given some amount at a fixed interval i.e. after every 3 months or after every 1 yr. The only thing which matters is that there should be equal distance between two installments. Compared to XIRR it is easy to calculate and you can find so many online IRR calculators.



WHAT IS XIRR?
IRR does not solve one problem and that is when the payments are at Irregular interval. In that case we use XIRR.

CALCULATION OF XIRR

IN XIRR compared to IRR we will take dates in addition as XIRR is for irregular intervals.  The formula for calculating XIRR is given below

where:
di = the ith, or last, payment date.
d1 = the 0th payment date.
Pi = the ith, or last, payment.


Note: A value of N/A will be returned when using this rate of return if the following conditions are
not met:
1. There must be at least one buy in the account.
2. An iterative technique is used for calculating XIRR. Using a changing rate (starting with
guess), XIRR cycles through the calculation until the result is accurate within 0.000001
percent. If XIRR can't find a result that works after 100 tries, the N/A error value is
returned.


Note: One thing which should be kept in mind while calculating IRR/XIRR is Net Present Value is zero (or We can say cash inflows -cash outflows is equal to zero)


if you need any help regarding xirr calculation mail me to :  chandraganeshchowdary@gmail.com