If I am having 6 flat files in data. How can you load the
data at a time
Answers were Sorted based on User's Feedback
Answer / sankar
for that 6 flat files make a one list file,then enter the
that 6 flat file paths in list file.
then session level select the type: inderect path:list file
patha filename:list
| Is This Answer Correct ? | 21 Yes | 0 No |
how the data will be loaded while desiging the schema?which one first (for e.g.-dimesions and facts)
how to declare array in plsql?
Can you use the maping parameters or variables created in one maping into any other reusable transformation?
Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me
What is resilience time?
Hi ETL gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance..please let me know in case of any concerns...
What are session parameters ? How do you set them?
hi i want to install latest informatica software in my pc..can anybody help me where should i get the infomatica software..plz help me
How can you join 3 tables? Why cant you use a single Joiner to join 3 tables.
What is the Router transformation?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What is a connected transformation?