i have one source 52 million records i want target only 7
records ?how wil you do what logic to implement?
Answers were Sorted based on User's Feedback
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 |
Answer / prakash kumar kumhar
can u tell me which 7 records u want?
Is This Answer Correct ? | 7 Yes | 0 No |
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 |
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 |
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 |
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 |
Which gives the more performance when compare to fixed width and delimited file ? and why?
How to handle decimal places while importing a flatfile into informatica?
In real time scenario where can we use mapping parameters and variables?
What are the different components of powercenter?
What is the difference between normal and bulk loading? Which one is recommended?
what is normalizer transformation?
How to call stored Procedure from Workflow monitor in Informatica 7.1 version?
. Design a mapping, first two phone calls received by a customer must be represented as "Home" , "Office" and the next calls must be concatinated and represented as "Other".Look at the below tables :: Source Definition Customer Phone_Number A 9848403211 A 9812675432 A 9112356788 A 9876503276 B 9567890765 B 9876098567 AND THE TARGET IS Customer Home Office Other A 9848403211 9812675432 9112356788,9876503276 B 9567890765 9876098567 Null
How to fasten loading of 100 million distinct records in informatica? (Initially they are loaded into target without using any transformation, taking 2 hours)
What are the rank caches?
in aggregator transformation we want to get middle record how to implement, source containg empno,name sal,deptno,address
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance