Interested to Buy Any Domain ? << Click Here >> for more details...
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 6987In 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 8006In 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 8281how many new transformations are introduced in 8.1 which are not available in 7.1? any new transformation in 8.6?
emc2,
2 5307suppose 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 13337we 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 9548while 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 4984What 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 10992lookup 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 8433differnece 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 6268Post New Informatica Questions
Explain direct and indirect flat file loading (source file type) - informatica
Performance tuning( what you did in performance tuning)
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
What is the function of aggregator transformation?
What are the advantages of using informatica as an etl tool over teradata?
can you please explain me pre session and post session options?
Explain the etl program with few examples.
Define Pmrep command?
What are the types of schemas we have in data warehouse and what are the difference between them?
How many ways are there to do 'remove duplicate records in informatica'?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
How to elaborate powercenter integration service?
In development project what is the process to follow for an etl developer from day1
Separate from a database, an information bazaar, and an information stockroom?
What is the procedure for creating independent data marts from informatica 7.1?
