Interested to Buy Any Domain ? << Click Here >> for more details...
My source data like...
Empid Name
10 chandra
10 sekhar
I am expecting result is
Empid Ename
10 Chandrasekhar
How can we solve this prob?
- 3 Answers
- 9644 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / shaik mahamad rafi
first use concatenate operator '',then use union
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
How do you convert single row from source into three rows into target?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
What is a passive transformation?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
How to create or import flat file definition in to the warehouse designer?
What are the settings that you use to configure the joiner transformation?
How to load the data from people soft hrm to people soft erm using informatica?
Can we override a native sql query within informatica?
Which transformation is needed while using the Cobol sources as source definitions?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
How to generate sequence numbers without using the sequence generator transformation?
