i have n number of records in my source, i want first and
last record to my target. how can u implement this scenario .

Answer Posted / chandrasekar

Hi Rakesh,

Please go through the above question because don't sort the
records what have the source as it is to load the records
for first and last.

Is This Answer Correct ?    4 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain scd type 3 through mapping.

777


I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

898


whats the logic to load the lower level of granularity of data to fact table.

2053


When do you use sql override in a lookup transformation?

800


State the limitations where we cannot use joiner in the mapping pipeline?

786


How to partition the Session?

859


How do you set a varible in incremental aggregation

1664


Under what condition selecting sorted input in aggregator may fail the session?

884


How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

1754


Explain pmcmd command usage in informatica

917


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

1912


What is joiner transformation in informatica?

849


What do you mean by DTM and Load manager and what is difference between load manager and load balancer?

864


What is the way to execute pl/sql script using informatica mapping?

1264


How many ways are there to create ports?

967