Which transformation should we use to normalize the COBOL
and relational sources?
Answers were Sorted based on User's Feedback
Answer / swetha
Normalizer Transformation.When yoU drag the COBOL source in
to the mapping Designer workspace,the normalizer
transformation automatically appears,creating input and
output ports for every column in the source.
Is This Answer Correct ? | 7 Yes | 0 No |
Answer / usha
by using normalizer transformation we can normalize the
COBOL and relational sources.when ever we drag COBOL
soureces in mapping designer by default normalizer
transformation appears
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / vikaskrmails@gmail.com
normalizer tr is specially used for Cobol sources because
its contains "Identified by" and "OCCURS" keyword that's
merge multiple record in one Normalized creates Generate-Key
and Genetrete column key for normalize it.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / bsgsr
hi,
swetha
wud you mind clarifying some queries of mine.
my mail id is bsgsr12@gmail.com
Is This Answer Correct ? | 0 Yes | 4 No |
What are roles and groups and benefits of using them?
What is the benefit of session partitioning?
i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table: pls full details
8 Answers L&T, TCS, UnitedHealth Group, Wipro,
Which tool yoU use to create and manage sessions and batches and to monitor and stop the informaticaserver?
my source is like this id,name sal 10 abc 1000,10 pqr 2000, 10 xyz 3000 ,10 jkl 4000 and my requirement is like this 10 abc,pqr,xyz,jkl 2000 .... i have try for this by using expression transformatin its ok of the concatenation of second column but the thing is that on third column if u group by using agg t/r the last value will com i.e 4000 but i asked by a interviewer that i dont want the first or last column i want the middle column i.e 2000 .plz reply for the same
How can you define a transformation? What are different types of transformations in Informatica?
Generally how many Fact Tables and Dimensions Table you have used in the Project? Which one is loaded first Fact Table or Dimensions Table into the warehouse? What is the size of the Fact Table and Dimension Table? what is the size of the table and warehouse
How can we create index after completion of load process?
What is a look up function? What is default transformation for the look up function?
Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me
In joiner, how to load Master table in Target?
There are n numbers of flatfile of exactly same format are placed in a folder .Can we load these flatfile's data one by one to a single relational table by a single session??