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 |
What is a rank transform?
Which tool yoU use to create and manage sessions and batches and to monitor and stop the informaticaserver?
i want to load data in to two targets..one is dimension table and the other is fact table?how can i load ata a time
My i/p is like below 1,2,3,4,5,6,7,8,9,10....100 I want that to be populated in two o/p as below o/p-1: 10,20,30,40,50,60,70,90... o/p-2: 11,21,31,41,51,61,71,81,91.... How to do it in ingotmatica...
tell me the rules and responsblites in our project(my project is development)
Is scd logic we have lookup right to compare the values with source and target,instead of lookup can u have any transformation or any way to do this?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
Enlist the tasks for which source qualifier transformation is used.
how to join the 2 different table with different columns in informatica?
two tables from two different databases r there . both having same structure but different data . how to compare these two tables ?
In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.