tell me 5 session failure in real time how can you solve that in your project?
what type of documents you receiving from client later wt can you do? what type of documents have to prepare?
explain about unit testing? in real time?
we have 30 wf with 3 batches means 1batch=10 wf 2 batch=10-20 wf 3batch=20-30wf through unix First you have to complete batch ofter second batch have to run how can you do in unix?1 5093
wf dont have integration severances how you can run?
How to Migrate the UNIX SCRIPTS from SIT TO PROD?1 1977
In ur current projectu have done any performance tuning of mappings?1 3658
In which scenario did you used pushdown optimization?1 2220
In Which scenario did u used Incremental loading?2 4909
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
Can we override a native sql query within informatica?
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
what is the -ve test case in your project.
What are the tuning techniques you applied during your last project
Define mapping and session?
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
Explain load alternative records / rows into multiple targets - informatica
What is a joiner transformation and why it is an active one?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
How to start a workflow using pmcmd command?
How to differentiate between the active and passive transformations?
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
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
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