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

1)how to generate sequnce numbers in informatica without
using sequnce genarator transformation.

2)i have number of records in my sourse, but iwant to
display first and last record only. how it is possible in
informatica.

3)i want to update the records without using updatestrategy
transformation.

4)what is diffrance between ab-intio and datastage than
compared to informatica.

5)what is the latest version of informatica in our field.

Question Posted / venkateshmalneni

Answer Posted / venkateshmalneni

i have number of records in my sourse, but iwant to
display first and last record only. how it is possible in
informatica.

Generate sequence numbers to ur source
connect it to filter t/r and write a condition sno=1 connect it to the target

in second pipeline connect source qualifier to aggreator t/r don't select any group by (so that it will gives it last record) connect output to the target

the flow is like this
sequence generator|
|
\|/
src--->sq--->filter--->target
|
|--->aggrigator--->target

Is This Answer Correct ?    15 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the databases that informatica can connect to windows?

587

What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?

1189

I have a flat file, want to reverse the contents of the flat file

698

Suppose we do not group by on any ports of the aggregator what will be the output?

582

Mention few advantages of router transformation over filter transformation.

642




which one is better performance wise joiner or look up

630

What are the advantages of using informatica as an etl tool over teradata?

569

What the difference is between a database, a data warehouse and a data mart?

599

What are active and passive transformations?

654

pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1055

What happens when a session fails and you click on recover?

660

Different circumstance which drives informatica server to expel records?

556

explain one complex mapping with logic? sales project?

6154

How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

629

Slowly changing dimensions, types and where will you use them

1278