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 / srinivasarao dasari
Find the count of the records using `wc -l` Command and
pass this to mapping varaiable.Now you can route the data
by dividing 2.I hope this would be helpful to you.
Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
What is domain and gateway node?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
without table how to come first record only in oracle?
expain about the tune parameters?
EXL informatica Questions
Explain informatica architecture - version 8 / 9
Enlist the various types of transformations.
What is meant by pre and post session shell command?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
What are the static cache and dynamic cache in informatica?
Is it possible to define a single node as a Gateway node as well as worker node?
How do you update the records with or without using update strategy?
Explain the code page compatibility?
What is domain in terms of informatica?
Is there any target staging area in informatica not staging area