1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

I want expect first and last record remaining all records will be loaded into target? which transformations we can use?

Question Posted / guest

Answers were Sorted based on User's Feedback



I want expect first and last record remaining all records will be loaded into target? which transfor..

Answer / ravikumar2614

Data flow like:
SRC-->SQ-->SEQ_GEN-->EXP-->AGGR-->FLTR-->TGT

create new port as M_PORT in Exp and leave empty.
write a logic in AGGR for M_PORT as MAX(SEQ_PORT)
Write a logic in FLTR as "SEQ_PORT!=1 AND M_PORT-SEQ_PORT!=0"

If my approach is wrong correct me on ravi.infop@gmail.com

Is This Answer Correct ?    14 Yes 5 No

I want expect first and last record remaining all records will be loaded into target? which transfor..

Answer / tanay

You can use Head and Tail commands in UNIX to achieve the
same. Please correct me if i am wrong.

Is This Answer Correct ?    5 Yes 2 No

I want expect first and last record remaining all records will be loaded into target? which transfor..

Answer / sudha

Src->sq->seq_gen->exp->agg->flt->tgt

create new port as M_PORT in Exp and leave empty.
write a logic in AGGR for M_PORT as MAX(SEQ_PORT)
Write a logic in FLTR as "SEQ_PORT!=1 AND SEQ_PORT!=m_port"

Please correct me if am wrong.

Is This Answer Correct ?    5 Yes 2 No

I want expect first and last record remaining all records will be loaded into target? which transfor..

Answer / rajesh

Use head and tail command(Pre session command) write it into two files.Use transformation to read that files as per your requirement

Is This Answer Correct ?    0 Yes 0 No

I want expect first and last record remaining all records will be loaded into target? which transfor..

Answer / kuldeep singh rathore

Src->sq->seq_gen->exp\_joiner->flt->tgt
---------->agg/


create a new port for count in agg and one dual port we assign 1 in that
and in exp also we add a port dual =1
we give condition in joiner on dual port
Write a logic in FLTR as "SEQ_PORT!=1 AND (count-SEQ_PORT)!=0"

Is This Answer Correct ?    0 Yes 0 No

I want expect first and last record remaining all records will be loaded into target? which transfor..

Answer / ashok

Sequence Generator

Is This Answer Correct ?    1 Yes 7 No

Post New Answer

More Informatica Interview Questions

How to load relational source into file target?

3 Answers   IBM,

why we need informatica

2 Answers   HCL,

what is surrogate id ?

3 Answers   IBM,

in my source table one of column contains the data like vishnraju@gmail.com,suresh@yahoo.com,krishna@hotmail.com these records i need to send in target table as below format. vishnuraju,suresh,krishna

5 Answers   Cap Gemini,

What is the difference between Power Centre and Power Mart?

5 Answers   TCS,




Using Expression transformation how to remove duplicate records from a relational source?

4 Answers  

Differentiate between Load Manager and DTM?

0 Answers  

What is the actual work done in Development and in the production depts in building a datawarehouse. Which dept is more interesting and career oriented .

1 Answers  

What is target update override

2 Answers   CTS,

In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?

2 Answers   Wipro,

Hi I have a source (flat file) like ID Name Attachments 101 abc [07012005072902]_CMM27-11-01 Page106 (2).pdf 102 bcd "[19012005124259]_Anfrage-Vendors.doc [19012005124336]_Anfrage.xls" 103 def "[19012006092602]_IMG_0310.JPG 19012006092631]_IMG_0311.JPG [19012006092702]_IMG_0312.JPG [19012006092727]_IMG_0313.JPG" But I need to generate duplicate records based on attachments column. Target (Table) like ID Name Attachments 101 abc [07012005072902]_CMM27-11-01 Page106 (2).pdf 102 bcd 19012005124259]_Anfrage-Vendors.doc 102 bcd [19012005124336]_Anfrage.xls 103 def [19012006092602]_IMG_0310.JPG 103 def [19012006092631]_IMG_0311.JPG 103 def [19012006092702]_IMG_0312.JPG 103 def [19012006092727]_IMG_0313.JPG 103 def [19012006092750]_IMG_0314.JPG 103 def [19012006092814]_IMG_0315.JPG Here no. of Attachments we can't decide because it is dynamic. It will be great if somebody help me on this. Thanks in Advance. ganga

2 Answers  

How many numbers of sessions can one group in batches?

0 Answers  

For more Informatica Interview Questions Click Here
Categories