Interested to Buy Any Domain ? << Click Here >> for more details...
explain the scenario for bulk loading and the normal loading option in Informatica Work flow manager ???
8 36905In router source is a boy age 20 I given 3 conditions in router a>20, a<=20, a=20 which one exit first?
3 8676what is the logic will you implement to load data into a fact table from n dimension tables?
TCS,
4 19806In a scenario I want to change the dimensions of a table and normalize the denomralized table which transformation can I use?
4 9035What is the method of loading 5 flat files of having same structure to a single target and which transformations I can use?
TCS,
8 25036On 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 13182In 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 10012Post New Informatica Questions
What is a snowflake schema?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
explan ur project architecture?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
How do you use reject loader.
Explain the mapping variable usage example in informatica
What are the tasks that can be performed using sq?
How you know when to use a static cache and dynamic cache in lookup transformation?
Can informatica load heterogeneous targets from heterogeneous sources?
What are active and passive transformations?
What is depict expression change?
What are the different lookup cache(s)?
Explain sessions?
How do you load only null records into target? Explain through mapping flow.
What is option by which we can run all the sessions in a batch simultaneously?
