Interested to Buy Any Domain ? << Click Here >> for more details...
My source table look like
ID Name Location Salary
1 ran NULL NULL
1 NULL DELHI NULL
1 NULL NULL 1000
I want my output to look like
ID Name Location Salary
1 ran Delhi 1000
What should be my approach to design a informatica mapping.
Assuming my source is flat file not a Relation table so i
cant use SQL.
- 2 Answers
- 6534 Views
- BirlaSoft, I also Faced
- E-Mail Answers
Answer Posted / rajan raorane
Use the below Mapping
Flat file-->SRC Qualif-->EXp-->Filter( With not null
condition on each port)-->Normalizer-->output
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
What is dynamic cache?
What are the different components of powercenter?
Mention few advantages of router transformation over filter transformation.
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
While migrating the data from one environment to another environment how would you manage the connections?
complex mapping ur project u r invlve can u explain and give real time example give me ?
What is Index Caches size?
Enlist few areas or real-time situations where informatica is required.
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
Mention some types of transformation?
what is Active lock explain
While importing the relational source definition from the database, what are the metadata of source that will be imported?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
