Interested to Buy Any Domain ? << Click Here >> for more details...
what is diff between IN and EXIT commands
- 1 Answers
- 7240 Views
- HCL, Schneider, I also Faced
- E-Mail Answers
Answer / kamesh
IN: Where they r 2 tables dept and emp the records which r
matched records present in both the table will displayed.
EXIT:the all records are displayed including the records
which are matched.
| Is This Answer Correct ? | 6 Yes | 0 No |
what happens if you try to create a shortcut to a non- shared folder?
what is fact and what types of fact tables is there
What is the need of etl tools?
How do you load alternate records into different tables through mapping flow?
Source-1 No name 1 satish 2 karthik 3 swathi 4 keerthi Source-2 No name 1 satish 2 karthik 5 santhose 6 vasu Target 3 swathi 4 keerthi 5 santhose 6 vasu here i want non matching Records i want how to achieve that
I have a file with data comming as 1,x1,x2,x3 2,a1,a2 3,b1,b2,b3,b4 1,y1,y2,y3 2,c1,c2,c3 3,d1,d2 my out put should be as follows x1,x2,x3,a1,a2,<null>,b1,b2,b3,b4 y1,y2,y3,c1,c2,c3,d1,d2,<null> Please let me know how can we acheive this in informatica Thanks in advance
Why we use stored procedure transformation?
in source one table is there. id value --- ------ 1 a 2 b 3 c 1 d 2 e 1 f in target i want id value ---- ------ 1 a,d,f 2 b,e 3 f How to implement it in informatica without using normalizer transformation?
If session fails after loading 10000 records in the target,how can we load 10001 th record when we run the session in the nexttime?
How can you join 3 tables? Why cant you use a single Joiner to join 3 tables.
1.what is SDLC of a project,explain in detail? 2.what are dimensions,facts?what is confirmed dimensions? 3.what is the need of OLTP? when we have datawarehousing?
What is a transaction control transformation?
Teradata 
