What is the method of loading 5 flat files of having same
structure to a single target and which transformations I can
use?
Answer Posted / arnab
Use Union transformation , if you do not want to use Union
and if your informatica runs on Unix , then create a shell
script to concatenate these files and create a single
file , you can call this shell script before you call the
session in the workflow
If you use windows create and dos batch script and do the
same as above
Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
What is the use of target designer?
What is an expression transformation?
Explain informatica architecture - version 8 / 9
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
What if the source is a flat-file?
What are multi-group transformations?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
What is a snowflake schema?
How does a sorter cache works?
pmscmd startworkflow -sv
Explain where to store informatica rejected data? How to extract the informatica rejected data?
What is the need for an etl tool?
How do you load only null records into target?
What the difference is between a database, a data warehouse and a data mart?