Interested to Buy Any Domain ? << Click Here >> for more details...
why we are using level option in normalizer transformation
- 1 Answers
- 6943 Views
- TCS, Wells Fargo, I also Faced
- E-Mail Answers
Answer / lokesh
If you want to see result in quarterly based with all other information like location, branch then we can go for normalizer transformation.
Your normalizer transformation looks like this for above example:
Field Level Occurs Description
Location 1 0
Branch 2 2 In each record we can see branch detail occurs two times
result 2 4 For each branch 4 times we can see quarter result, so in a record 4(occurs) X 2 (level) = 8 times
It automatically create input/output port depends on your level and occurs. Also generates some output key ports. You can see more detail on key port in help material.
| Is This Answer Correct ? | 0 Yes | 0 No |
In which circumstances that informatica server creates Reject files?
sample mappings for scd1,scd2 and scd3
suppose we will take flatfile target and load type is bulkload the session fails why please give me the answer
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
how we do performence tuning in informatica
wt is inline view? when and why we Use ?mail to rayallarv@gmail.com
write sql query following table quarter sales q1 1000 q1 2000 q1 3000 q1 4000 q2 5000 q2 6000 q2 7000 q2 8000 q3 1000 q3 2000 q3 3000 q3 4000 q4 5000 q4 6000 q4 7000 q4 8000 i want the output format like q1 q2 q3 q4 1000 5000 1000 5000 2000 6000 2000 6000 3000 7000 3000 7000 4000 8000 4000 8000
if we hav 10 records in a file, can we get first record from it by using Aggregator with out using Groupby Port in it?If Yes..let me know the answer plz!!!
Howmany ways yoU can update a relational source defintion and what are they?
Can we update the data in flat file using update strategy?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
How to delete the data in the target table after loaded.
Teradata 
