-
User Defined Environment Variables
What is the use of the User defined Environment variables?
-
Unconnected lookup
What is the use of unconnected lookup transformation and exaplain with example?
-
-
-
Assignment Task
Why we use assignment task in Informatica and what happens after we used it?
-
Sql server scenario
How to get the below output for following table ? can you please clarify this
--------------------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------------------
--------------------------
100 | null | null | null
-------------------------- -
Generate Negative Sequence
How to generate a negative sequence by using sequence generator?
-
ETL Row number, Rank and Dense Rank
What is row number, rank and dense rank? What are its uses?
-
ETL Case and Decode
What is the difference between case and decode?
-
Output of Partition by Key
IF we have a records like below with 2 way mfs using a partition by key, what will be the output.
Key here is Index(Column name)
Index
1
2
3
4
5
5
4
3
2
1 -
Informatica Power Exchange
Explain about Informatica Power Exchange
What are the important points in Informatica Power Exchange -
ETL-Validation Landing Area to Staging Area
What are the validations you perform from landing area to staging area?
-
Missing Record in Target
How you will find the missing record in the target without using Minus?
-
-
-
-
-
-
-
ETL Interview Questions
Ans