i have one source 52 million records i want target only 7 records ?how wil you

Categories >> Software >> Data Warehouse >> Informatica
Suggest New Category

i have one source 52 million records i want target only 7
records ?how wil you do what logic to implement?

Question Posted / dinesh

7 Answers
11673 Views
L&T, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

i have one source 52 million records i want target only 7 records ?how wil you do what logic to im..

Answer / vijay

Are you saying you want the first 7 records from the source
table?

If that is the case, write an override in source qualifier
and fetch by the row number. That would be the fastest
way.Load into target.

Is This Answer Correct ?

9 Yes

1 No

i have one source 52 million records i want target only 7 records ?how wil you do what logic to im..

Answer / prakash kumar kumhar

can u tell me which 7 records u want?

Is This Answer Correct ?

7 Yes

0 No

i have one source 52 million records i want target only 7 records ?how wil you do what logic to im..

Answer / amedela chandra sekhar

IF U WANT LOAD 7 RECORDS FROM SOURCE TO TARGET,
WE CAN USE SEQUENCE GENERATOR T/R
CURRENT VALUE =0
END VALUE =7
RESET ENABLE
THEN DRAG THE NEXTVAL PORT TO EXP T/R
CREATE ONE OUTPUT PORT GIVE THE CONDTION LIKE NEXTVAL =7.

PLZ LET ME IF ANY WRONG

Is This Answer Correct ?

4 Yes

0 No

i have one source 52 million records i want target only 7 records ?how wil you do what logic to im..

Answer / jacob

take one sequence generator and poppulate the sequence nos
to all rows then give condition as sequence no<=7.

Is This Answer Correct ?

3 Yes

1 No

i have one source 52 million records i want target only 7 records ?how wil you do what logic to im..

Answer / sameer

If our source as a relational table then we write sql queries in sour economy qualifier transformation select * from table-name where rownum <=7
But if our soure as flat file

Is This Answer Correct ?

1 Yes

0 No

i have one source 52 million records i want target only 7 records ?how wil you do what logic to im..

Answer / sameer

If ur source as a flat filemail then we uses first expression transformation and we write expression v1=v1+1 and one output port o1=v1 then after filter transformation and in there filter conditions just write o1 <=7 But if ur source as a relational source then we write select * from table-name
Where rownum <=7

Is This Answer Correct ?

1 Yes

0 No

i have one source 52 million records i want target only 7 records ?how wil you do what logic to im..

Answer / chandra

you create a Rownum port in target system and use the Ex/T u create o_port in Expression edition give the logic is Rownum<=7

Its Right Or Wrong Please...........Tell me

Regards
Chandra

Is This Answer Correct ?

0 Yes

0 No

Post New Answer