What are the uses of etl tools?
No Answer is Posted For this Question
Be the First to Post Answer
Explain one complecated mapping?
wht is cdc?how to use it in creation of mappings?
What are the static cache and dynamic cache in informatica?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
In a sequential batch can you run the session if previous session fails?
In a table there are 1 million records there in which 3 records are duplicate how will you find out those 3 records?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b,the target shd be loaded as 1 a+b+c or 1 a||b||c, what transformations shd be used for this?
In development project what is the process to follow for an etl developer from day1
Do joiner transformation use cache? If so describe?
What is a taget load order?
we have a parameter file in Unix location where we have .txt files and those file will be used as source in informatica. I cannot use source file name directly as file name will keep on changing in unix location. I need to define $$InputFile as parameter. Can anybody send me the parameter file and the steps to handle this.
What are the ETL tools available in DWH?