Interested to Buy Any Domain ? << Click Here >> for more details...
How can you join 3 tables? Why cant you use a single Joiner to join 3 tables.
- 1 Answers
- 2898 Views
- I also Faced
- E-Mail Answers
Answer / ranjan
Sql only allow us to join only two tables at a time because intersection/union methodology can only possible in two tables .
| Is This Answer Correct ? | 0 Yes | 0 No |
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
wtite sql query following table are city gender no chennai male 40 chennai female 35 bangalore male 10 bangalore female 25 mumbai female 15 i want the output? city male female chennai 40 35 bangalore 10 25 mumbai null 15
What is a sorter transformation?
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
WE HAVE 10 RECORDS IN SOURCE IN THAT GOOD RECORDS GO TO RELATIONAL TARGET AND BAD RECORDS GO TO TARGET FLAT FILE ? HERE IF ANY BAD RECORDS MEANS ITS LOAD INTO FLAT FILE AND SEND AN EMAIL , IF NO BAD RECORDS MEANS NO NEED TO SEND EMAIL . PLZ HELP ME ...
i want to load data in to two targets..one is dimension table and the other is fact table?how can i load ata a time
i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table. can any tell me procedure.
what is the use of Java Transformation in Informatica 8.x?
following table source name gender a1 male a2 female how to change 'male' to 'female' and 'female' to 'male'
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
Hi Experts, I have a source table like this. Name Number Raj 2 Ram 1 Sam 2 John 1 In the target I need the ouptput like the below Raj Raj Ram Sam Sam John We dont know the number value . It will be changing as n.. Please help me regarding this. Thanks, Nataraj V
What the difference is between a database, a data warehouse and a data mart?
Teradata 
