Find the count of the records using `wc -l` Command and pass this to mapp

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.

Question Posted / srinivasarao dasari

10 Answers
16423 Views
I also Faced
E-Mail Answers

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

Please Help Members By Posting Answers For Below Questions

What are some examples of informatica etl programs?

948

Which files are created during the session rums by informatics server?

1189

can anyone suggest best free Talend data integration training online

1698

What is joiner transformation?

1016

How can we remove the duplicates from flat file source?

1047

How can we use batches?

1031

What are the popular informatica products?

1017

What is different between the data warehouse and data mart?

1077

While importing the relational source definition from the database, what are the metadata of source that will be imported?

1276

What are the reusable transformations?

1170

How you can differentiate between connected lookup and unconnected lookup?

1064

What are junk dimensions?

1076

How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

1095

is it possible to index the data in cache of lkp transformation ?

2033

What is expression transformation?

1108