1)can anyone explain how to use Normalizer transformation
for the following scenario
Source table | Target Table
|
Std_name ENG MAT ART | Subject Ramesh Himesh Mahesh
Ramesh 68 82 78 | ENG 68 73 81
Himesh 73 87 89 | MAT 82 87 79
Mahesh 81 79 64 | ART 78 89 64
|
please explain what should be
the normalizer column(s)
The GCID column
2)Also please explain the Ni-or-1 rule.
- 5 Answers
- 25486 Views
- FCS, IBM, Satyam, TCS, I also Faced
- E-Mail Answers
Answer Posted / murthy
I'm not expert , actually i'm a new commer on datastage
i think this problem can be achieved by using pivot stage
because it converts the multiple columns data format in to
the multiple rows format, so i think it will be useful for u
thanks
murthy
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What are the different versions of informatica?
expain about the tune parameters?
4 yrs etl devloper roles and responsibilities?any body give solutions
While migrating the data from one environment to another environment how would you manage the connections?
Explain what are the different types of transformation available in informatica.
What is the function of union transformation?
What is exclusive and normal mode for repository services?
How might you approve all mappings in the archive all the while?
Enterprise data warehouse your projects phase by phase explain?
Which means the first record should come as last record and last record should come as first record and load into the target file?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
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?
What is target load order?
How can we update a record in the target table without using update strategy?
Explain the etl program with few examples.
