i have two flat files.. containing same type of data
i want to load it to dwh..how many source qualifires i need
Answer Posted / raman m
If the 2 flat files have the same structure,then we can go
for filelist concept in informatica.
only one source qualifier is needed and the source should
be either of the flat files.
| Is This Answer Correct ? | 32 Yes | 0 No |
Post New Answer View All Answers
what are the Methods For Creating Reusable Transformations?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
Briefly define reusable transformation?
Explain what is informatica metadata and where is it stored?
lookup transformation with screenshots
What are the measure objects?
scenario where i can use only concurrent execution of workflow.
What are the basic requirements to join two sources in a source qualifier transformation using default join?
Name the different lookup cache(s)?
What are the main features of Oracle 8i with context to datawarehouse?
Scheduling properties,whats the default (sequential)
what is song in infrmatica...?
Explain dynamic target flat file name generation in informatica
How would you copy the content of one repository to another repository?