explain the scenario for bulk loading and the normal loading option in Informatica Work flow manager ???
8 34280In router source is a boy age 20 I given 3 conditions in router a>20, a<=20, a=20 which one exit first?
3 7557what is the logic will you implement to load data into a fact table from n dimension tables?
TCS,
4 18038In a scenario I want to change the dimensions of a table and normalize the denomralized table which transformation can I use?
4 7472What is the method of loading 5 flat files of having same structure to a single target and which transformations I can use?
TCS,
8 22392On a day, I load 10 rows in my target and on next day if I get 10 more rows to be added to my target out of which 5 are updated rows how can I send them to target? How can I insert and update the record?
6 11084In a scenario I have col1, col2, col3, under that 1,x,y, and 2,a,b and I want in this form col1, col2 and 1,x and 1,y and 2,a and 2,b, what is the procedure?
5 8460Post New Informatica Questions
What is the use of code page?
What if the source is a flat-file?
What are active and passive transformations?
What is a shortcut and copy in Informatica and how two are different with each other?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
What are the new features of informatica 9.x in developer level?
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 an aggregator transformation?
Tell me about Propagate functions in informatica
how to create user defined function (udf) in informatica
What is a grid in Informatica?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?