Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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.

Answers were Sorted based on User's Feedback



hi all, i have 1 flat file having 10 rows. like:- id name amt 100 a 100 200 ..

Answer / rashmi garg

From source to expression connect ID, Name and Amt.
Add one sequence generator and connect to expression
now expression TF is like

expression
----------
ID
Name
Amt
Number

pass number port to aggregator TF to get the max value in
number and pass ID,Name, amt and number from exression to
router and max value from aggregator to router
now router is having ports
Id
Name
Amt
Number
Max

now route the rows on the basis of
number < max/2 (output group 1)
number > max/2 (output group 2)

Is This Answer Correct ?    17 Yes 5 No

hi all, i have 1 flat file having 10 rows. like:- id name amt 100 a 100 200 ..

Answer / honey

when u apply the procedure given by Mr.Ramesh u will get
alternative records to be stored in the two flatfiles.
Is this what u wanted.

Is This Answer Correct ?    5 Yes 2 No

hi all, i have 1 flat file having 10 rows. like:- id name amt 100 a 100 200 ..

Answer / romi

Thanks to all,

But i want to store first half data in 1 table and another
half in another table. and with procedure i m getting
alternative data.

Is This Answer Correct ?    1 Yes 1 No

hi all, i have 1 flat file having 10 rows. like:- id name amt 100 a 100 200 ..

Answer / 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

hi all, i have 1 flat file having 10 rows. like:- id name amt 100 a 100 200 ..

Answer / psnadh

Hi,

In the source file if the row count is odd number,then how
can we check the condition to divide the ff into two halves?

If it is even,we can divide the ff into two halves as per
the above solutions.

Please give me reply how to implent that

Thanks in Advance

Is This Answer Correct ?    1 Yes 1 No

hi all, i have 1 flat file having 10 rows. like:- id name amt 100 a 100 200 ..

Answer / shashank

source->SQ->exp[dummyRow=1]->sorter[sort by dummyRow]->
(input to 2 transformation,pipeline branching)
1. joiner[normal join on dummyRow]
2. aggregator[no group by,add port TotalNoOfRows with
expression COUNT(dummyRow)]
Sequence generator->joiner{say port name be RowNo}
{so, joiner will get input from 3 trn, sorter, seq gen &
agg}
Joiner->exp[add port halfNo with exp iff
(RowNo<=TotalNoOfRows/2,1,2)]-> router[halfNo=1,halfNo=2]
->Target1(if halfNo=1)
->Target2(if halfNo=2)

Is This Answer Correct ?    1 Yes 1 No

hi all, i have 1 flat file having 10 rows. like:- id name amt 100 a 100 200 ..

Answer / indra

NOT GOT APPROPRIATE RESULT BY GOING THROUGH THE SOLUTION
GIVEN BY Shashank....

Is This Answer Correct ?    0 Yes 0 No

hi all, i have 1 flat file having 10 rows. like:- id name amt 100 a 100 200 ..

Answer / bsgsr

send the flat file data into an expression transformation
and create a new pory say xyz and connect nextval mport on
seq_gen to this. then connect expression to router take two
groups. using the nem port created write conditions.
newport<5 in first group ice versa. i believe this would
work

Is This Answer Correct ?    1 Yes 3 No

hi all, i have 1 flat file having 10 rows. like:- id name amt 100 a 100 200 ..

Answer / bala ramesh

in this logic , frist take one sequene genrator
transformation ,pass next value to expression
transformation and also pass id,name,and amt.
in this transformation and also create one output port
(temp).it is decimat type and write codition like
(iif(NEXTVAL %2=0,0,1)) , after take one router
transformation ,pass these ports (id,name,amt and
temp) .then create two group ,one is temp=0 and another one
is temp=1.after pass first group to one flat file ,second
group to second flat file.

Is This Answer Correct ?    3 Yes 6 No

hi all, i have 1 flat file having 10 rows. like:- id name amt 100 a 100 200 ..

Answer / sajjan

solution1:- use rank transformation, divide into two
quartiles and pass them to different targets

Is This Answer Correct ?    0 Yes 4 No

Post New Answer



More Informatica Interview Questions

how can we update without using update transformation. wt is push down operation in informatica. which lookup gives more tuning performance. if so why.

6 Answers   CTS, Symphony,


which one is better performance wise joiner or look up

0 Answers   Informatica,


There are 4 source files which contains same metadata create target that should display the file name along with record please send answer with mapping

3 Answers   Wipro,


What is decode in informatica?

0 Answers  


what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

0 Answers   Wipro,






How do you load unique records into one target table and duplicate records into a different target table?

0 Answers  


what are the fact table & dimensional table in pharmaceutical and hospotal related products???

0 Answers   IBM,


What is the difference between stop and abort in informatica

0 Answers   Informatica,


Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

0 Answers  


When will u go for Dynamic Cache and Persistent Cache? Pls explain with an example?

2 Answers   TCS,


What are the tasks that Loadmanger process will do?

1 Answers  


Explain constraint based loading in informatica

0 Answers   Informatica,






Categories