In Lookup transformation a sql override should be done and
disable
the cache how do you do this procedure?
i have 1000 record flat file source i want 1st row to 1st target, 2nd row to 2nd target, 3rd row to 3rd target how will u do? Without using Mod Function? Explain....
What is polling in informatica ?
Filter transformation in the condition one of the data is NULL would the record be dropped.
What is the need of an ETL tool?
What is a stored procedure transformation?
In a mapping i have three dimensions. If i want to pass a same surrogate key value to all the three dimensions by using one sequence generator is possible?If the mapping is containing single flow? And in the same case if the mapping is contaning 3 flows for the three dimensions then by using one sequence generator can we populate surrogate key (same value) to all the three dimensions?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
Hi All, i have question regarding Change Data Capture in Informatica. As i know we can do this using Incremental Aggregation(i never worked on Informatica but i read) and i think we can do the same with SQL Over write and with variables. Can someone tell me how do we do this using other two techniques.. using SQL Over write and variables. Thanks for the help and greatly appreciated.
Explain the difference between a data warehouse and a data mart?
can we use lookup t/r in flat files?what are the t/r's can be used in flat files when compared to relational DB?
Partition, what happens if the specified key range is shorter and longer
Using Expression transformation how to remove duplicate records from a relational source?