hi all, i have 1 flat file having 10 rows. like:-
id name amt
100 a 100
200 b 200
100 n 300
400 p 3000
100 a 100
600 x 6000
Now i want to load half of this data into one flat file and
remaining in other flat file.like :-
flat file 1
id name amt
100 a 100
200 b 200
100 n 300
----------------------
----------------------
flat file 2
id name amt
400 p 3000
100 a 100
600 x 6000
Plz reply me ASAP.
Answer Posted / indra
NOT GOT APPROPRIATE RESULT BY GOING THROUGH THE SOLUTION
GIVEN BY Shashank....
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the guidelines to be followed while using union transformation?
Define joiner transformation?
whats the logic to load the lower level of granularity of data to fact table.
What is a router transformation?
What is joiner transformation in informatica?
What is meant by lookup transformation? Explain the types of lookup transformation?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
What are the advantages of using informatica as an etl tool over teradata?
What are the components of workflow manager?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
Explain lookup transformation source types in informatica
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 EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
How do you load only null records into target?
What is an aggregator transformation?