-
How would you explain about Informatica Project ?
Can any one please tell me how to explain Data warehouse project in interview and from where to start and end. what to explain completely in it(data warehouse project), how much hast to explain from it(dw project) and what is architecture of it and data flow and construction of dw project or data warehouse.what is data warehouse methodology ,types of dw methodology, most using dw methodology in companies...
-
-
How do you change the transformation?
On one day there are 10 cities and the other day 5 more cities gets added? then how do you change the transformation? What do you do?
-
How would you do mapping with flat file and Oracle as source ?
One source is flat file and other source is oracle, then how do you do the mapping?
-
-
What is the main difference between mapping and mapplet designer ?
What is the main difference between mapping and mapplet designer in etl informatica and what transformations are used in the both?
-
Explaining Informatica projects
Can any one please tell me how to explain Data warehouse project in interview and from where to start and end. what to explain completely in it(data warehouse project), how much hast to explain from it(dw project) and what is architecture of it and data flow and construction of dw project or data warehouse.
what is data warehouse methodology ,types of dw methodology, most using dw methodology... -
Changing the rows from source to target
hi, hi can anybody answer my query... that is i had a source table containing for eg;D1,D2,D3,D4,D5 one by one that means in a each column contains single source i.e., D1 in 1st col,D2 in 2nd col so on now i want in my target like D1-D2 in one col, D1-D2_D3 in other col,D2_D3-D4 in other col and D3-D4-D5 in other col plz send as soon as possible.......... thanx in advance
-
-
-
Pipeline Partitioning
Explain the pipeline partitioning with real time example.
-
-
Unconnected lookup
Supose we have 4 column based on same condition can we use unconnected lookup in that case?
-
Passive Router Transformation
Router is passive transformation, but one may argue that it is passive because in case if we use default group (only) then there is no change in number of rows. What explanation will you give?
-
$ & $$ in Mapping or Parameter File
What is the difference between $ & $$ in mapping or parameter file? In which cases they are generally used?
-
Mapping Parameter Usage
Can any body suggest the practical example where mapping parameter or variable is used, Please suggest the same for session parameter and variable..?
-
-
Loading data to multiple targets
How to create mapping that half records will go to one target and half to another target?
-
Aggregate Value
Explain a mapping design to start aggregating the values before getting all the rows from the source.
-
Update Strategy Transformation
Why the input pipe lines to the joiner should not contain an update strategy transformation?
Informatica Interview Questions
Ans