hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?

1364

Can we override a native sql query within informatica?

440

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

1259

what is the -ve test case in your project.

1625

What are the tuning techniques you applied during your last project

1392

Define mapping and session?

434

in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

1531

Explain load alternative records / rows into multiple targets - informatica

496

What is a joiner transformation and why it is an active one?

419

what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

1754

How to start a workflow using pmcmd command?

521

How to differentiate between the active and passive transformations?

466

5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

1230

Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

1480

How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how

983