suppose we have 1 to 10 records.In router transformation we had given two condition A>= 5 A<=5 then what will be the output?
emc2,
2 5978In update strategy t/r we had given dd_insert condition & in session we gave delete condition . Then what will happen? mapping will run ?
emc2,
3 6708In SCD type 2 if we had select date range. then suppose we had inserted today's date(eq. date is 30 aug 2010) then start date will be today's date(30 aug 2010) what will be the end date,we cant leave it blank?
2 7157how many new transformations are introduced in 8.1 which are not available in 7.1? any new transformation in 8.6?
emc2,
2 4340suppose i have 1000 records and i want to load half of the record in target 1 and half in target2.how u'll do?
IBM,
9 10620we have three columns and two rows. col1 col2 col3 a b c want to change into 2 columns and 3 rows ,how? col1 a col2 b col3 c which transformation u'll use and how?
3 7984while for 100 records in source table loaded sucessfully in trgt table . assume ,session will take 10min or 5 min to successfully succeeded. then 100 million records r there in source how much time will take by session to succeeded. there no fail ok.trgt table will load 100 million records with out any errors . don't tell perfect time . assume your self how much time to succeeded?
IBM,
1 4313What type of sorting algorithm does the Sorter Transformation use, to do its sorting Operation? 1. Bubble sort 2. Insertion sort 3. Shell sort 4. Merge sort 5. Heapsort 6. Quicksort 7. Bucket sort
3 9829lookup is passive y can't it be active? let us say i have some records in my source like 101,rohit,1000 101,rohit,1000 102,kumar,2000 like wise now as it is having multiple matches i return only first,last value it can't return bouth the values that means lookup is acting as select distinct right by default what means it is active?
IBM,
5 6851differnece between joiner and a look up(please don't give just definitions)....i mean in which scenario it is better to use joiner and in which scenario better o use lookup ??
IBM,
2 5196Post New Informatica Questions
What are the different versions of informatica?
What are Dimensional table?
Why union transformation is an active transformation?
Enterprise data warehouse your projects phase by phase explain?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
What is the difference between a repository server and a powerhouse?
Explain the use of aggregator cache file?
How can we delete duplicate rows from flat files?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
tell me 5 session failure in real time how can you solve that in your project?
What is mapping debugger?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
What are the static cache and dynamic cache in informatica?
What is an Integration service in Informatica?
What you know about transaction control transformation?