Answer / giri

Tranformation is extract data from one data to another data base in condition,

Answer / prasad

Transformation is a power center object which allows you to
define a business logic for processing the data or
converting the data one format to another format.

two types: active and passive

Answer / praveen.madishetty

A Transformation is a type of metadata object which is
responsible for transforming the data or processing the data

Answer / surya

When transfering the data from Source to Target,we used
multiple steps that steps in informatica is called as
transformations.

Answer / swetha

It is a repostitory object that generates, modifies or
passes data.

case and like function in informtica (my source is XML). case when OS Like'%Windows%' and OS Like '%200%' then 'Windows 200' case when OS Like'%Windows%' and OS Like '%200%'and OS like '%64%' then 'windows 200 64 bit' etc.,,

1 Answers  

Hi ETL gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance..please let me know in case of any concerns...

1 Answers  

What is the sql query overwrite in source qualifier in informatica

0 Answers   Informatica,

The structure of source file is as below: Source structure(two fields) Name, Card NUmber A, 111111111(SSN) A, 01010101(Creditcard number) A, 34343434(Debit card number) B, 55555555(Creditcard number) C, 77777777(Debit card number) Target Structure(4 fields) Name,Credit card,SSN,Debit card A,01010101,111111111, 34343434 B,55555555,, C,,,77777777 Corresponding to one name there can be maximum 3 rows and minimum zero rows. Given that I do not know which record might have a particular type of number. How can I handle above requirement with informatica transformations?

1 Answers   Amdocs,

What is informatica worklet?

0 Answers  

What are the different tools in workflow manager?

1 Answers  

explain abt joiner t/r?

1 Answers   IBM,

If sal is null then replace it with min(sal). Can any one write a query for this in oracle ? Advance Thanks

7 Answers   Puma,

Explain factlessfact table with scenario

1 Answers   HCL,

Without using any transformations how u can load the data into target?

15 Answers   IBM,

which one is better performance wise joiner or look up

0 Answers   Informatica,

8.what is mapplet ?give example?

2 Answers