Answer / cooldude

Sorter will be costliest transformation as it uses
temporary cache and its size is approximately to the size
of RAM.

Answer / savita

hi guys,
some one selected that Above ans is worng.. can any one
tell correct answer.for the above Question

Answer / srikanth

HI

Among those 3 trans, filter does not use cache.

so it should be either agg or sorter.

Both agg and sorter uses cache as they process data in a
dependable fashion for performing calculations and sorting
data before the result is passed to next transfomration.

WE cant say which one uses more space. it depends on the
size of source data we are processing.

Agg needs to perform calculations on groups of data but if
the data in sorter is more, it takes more space than agg to
hold the data.

for ex, we are sorting on character data, server needs to
use ASCII values of alphabets to sort in order.

It depends on the size of the source data.

Answer / jyothiram

XML is costliest transformation after sorter.

XML--- 10 units
sorter---8 units
lkup,joiner,agg,rank-(index)-1 unit

lkup,joiner,agg,rank-(data)-2 unit

These are the order of costlier in cache making

Answer / krishna

hey raj, pooja and savita the costliest transformatin till
Infa7.1.4 is lookup but after Infa 8.1 it guess it sj=hould
be JAVA.

Answer / pooja

HERE YOU MENTIONED ONLY 3 TRANSFORMATION, SO OUT THESE 3
aGGREGATOR IS COSTLIEST TRANS

Answer / raghu

aggregater is costliest bcoz it have cache, remaing d'snt
have cache

where actually the usage of push down optimization happens...

2 Answers  

i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table. can any tell me procedure.

2 Answers   TCS,

what is parameter file?

1 Answers   Cap Gemini,

Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks

0 Answers   IBM,

I have one source table and three target tables. When the session runs for the first time involving the mapping,i want that the loading should take place in 1st Target table only. The 2nd time the same session runs the loading should take place in 2nd Target only only and similarly when the session runs for the 3rd time loading should take place in Third only. And again when the session runs for the 4th time loading should take place in 1st Target table.

4 Answers   Cap Gemini, IBM,

How to delete the data in the target table after loaded.

3 Answers   TCS,

i have 1000 record flat file source i want 1st row to 1st target, 2nd row to 2nd target, 3rd row to 3rd target how will u do? Without using Mod Function? Explain....

4 Answers   TCS,

can we load the data with out a primary key of a table? what is target plan?

6 Answers   IBM,

what is correlated query?

2 Answers   IBM,

What are the new features in Informatica 5.0?

1 Answers  

Had any one faced informatica(ETL/Developer), Datawarehouseing interview in UK. Than plz help me (i have any exprience of 3yrs informatica,datawarehousing,oracle,teradata) 1.hw the procedure will b here 2. wht type of question's they will b asking. 3.In which area they concertate more. since this is the first time im facing interview in UK. plz help ASAP.it will b a great help for me thanks to All in Advance

2 Answers  

in aggregator transformation we want to get middle record how to implement, source containg empno,name sal,deptno,address

1 Answers   Cognizant,