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?
- 2 Answers
- 6970 Views
- emc2, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / mike
If you create two groups in the router transformation and
you want to load the records in to two target tables then
src-->srcq--->router-->/t1
\t2..The records which meet the
condition in the first group will pass in to the T1 and the
records which meet the condition in the second group will
pass in to the T2...i mean to say all the records that
matches the condition will come as an output
correct me if i was wrong
| Is This Answer Correct ? | 7 Yes | 6 No |
Explain in detail about scd type 1 through mapping.
What is a code page in Informatica
3 Answers American Express, Cognizant, Deloitte,
i have a source with 100 records.i have 2 targets.in the first target i want to load first 50 records & in the second target i want to load next 50(or remaining) records.
Name 4 output files that informatica server creates during session running?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
What are the types of schemas we have in data warehouse and what are the difference between them?
What are the types of maping in Getting Started Wizard?
What is factless fact schema?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
My source is flat file which contain only one column with data type varchar.now i want to send string data types into one target and if any numbers and special characters are there that should be send it into another target.so how do you design a mapping for this?
Hi If i had source like unique & duplicate records like 1,1,2,3,3,4 then i want load unique records in one target like 2,4 and i want load duplicate records like 1,1,3,3 then can any body please send me what is th scnario. my mail i shek.inform@gmail.com
Hello, I have the below table: CityID CityName CostOfLiving 1 Mumbai 5000 1 Bangalore 4500 1 Chennai 4800 2 Vapi 6000 3 New Delhi 8000 I am passing the rows of the above table through the aggregator transformation in Informatica What happens in the following conditions: 1) I specify no group-by ports? 2) I specify a group-by on CityID without making any separate post for aggregation? Which city and costofliving will this eventually take for CityID=1? 3) Rest being same as point 2,I take the sum of cost of living.Which city will be returned for ID=1? Thanks for your help!
Teradata 
