When to use normalization transformation other than cobol
source?
Answers were Sorted based on User's Feedback
Answer / chandra
by using normalizer we can normalize the data .
means a single input record can be devided into multiple
data records.
This process is also called as datta pivot.
Regards
chandrababu Naidu
| Is This Answer Correct ? | 11 Yes | 0 No |
Answer / abdulquadir atif
Hi,
We use Normalizer for COBOL sources and also to split data,
which means de-normalizing. If you want to change columns
to rows and vice versa.
Atif
| Is This Answer Correct ? | 1 Yes | 0 No |
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
task is running successfully but data is not loded why?
Can i create a lookup table without cache.
How to open an older version of an object in the workspace?
Difference between session variables and workflow variables?
source file name xyz a,0,a,a,a b,b,b,0,b c,c,c,0,c target should be like this xyz a b c how to implement this?
hi, as al you know, we can set the option in session level as all rows treat as like insert,update etc., And also we have update strategy for flaging records as insert,update etc.. then when we will go for above options and what is the difference.. explain..
For stage table data processing, suppose in first run we processed 8 records out of 10 records then in 2nd run we should consider only not processed records (here total no of records =2) along with new records which got loaded in stage table thru real time mapping. Note : In this example, 8 records are those records for which we got transaction number after lookup on trn_no_cod table and 2 records for which lookup returns trn_no as NULL
I am getting five sources in a day and i donot know when i get them. i need to load data into the target and run the session. but here i can't keep the session in running or can't stop the session. plz help me
What are the new features of Power Center 5.0?
i have a flat file and the file s are like below ****%%^^@@@G**@#A@#$N*&^E%^S@#h@@@##$$ IN THIS FORMATE Means un limited special charecter between and sides of the string data..output should be(GANESH) HOW YOU HANDEL THIS TYPE OF RECORDS,,COZ U DON"T KNOW WHERE AND WHAT ARE THE SPECIAL CHARACTERS IN BETWWEN THE NAME...
I am having source ENO ENAME LOC 1 A PUNE 2 B MUMBAI 3 C CHENNAI Target ENO ENAME LOC 1 A PUNE 2 B MUMBAI 3 C CHENNAI If a new record coming from source from same location it should directly go to specified location in target at begining EX:if Eno with 4 coming from same Pune, It should directly load into the Pune location col with '|' symbol. Help me its very urgent