HI,
I need inputs please..
I have a mapping with a single stream and 3 oracle Target instances of the same table..
For the 1st and 2nd target instance i need to insert data and for the 3rd instance do a lookup on the target table, but the problem being the data has not been commited to the...
Hi,
I have a strange request...
I need to split a row into multiple rows..
for ex..
if there is row with max 8 columns i.e.
101 102 103 104 105 106 107 108 8
With 8 indicating the depth (This above could be of depth or level 1 or 2 or 3...8), i need this to be loaded into a target table...
Can anyone let me know, if in a mapping there are two independent streams and i need to pass the value of one port from one stream to another, once the first stream has processed the data..
I do know you can store the value in Temp table and do a lookup in the 2nd stream but is there a way where...
Is there a better way of writing this...code
IIF(
(OUT_REC_TYPE ='10')
OR
(OUT_REC_TYPE = '12')
OR
(OUT_REC_TYPE = '14')
OR
(OUT_REC_TYPE = '16')
OR
(OUT_REC_TYPE = '18')
OR
(OUT_REC_TYPE = '20')
OR
(OUT_REC_TYPE = '22')
OR
(OUT_REC_TYPE = '24')
OR
(OUT_REC_TYPE = '25')
OR
(OUT_REC_TYPE = '26')...
IS IT GOOD HAVE ALL YOUR TRANSFORMATION LOGIC, IF POSSIBLE TO BE DEFINED IN ONE EXPRESSION IN A MAPPING OR TO SPLIT INTO MULTIPLE EXPRESSIONS?
Which of the above methods are efficient.
Hi,
Could anyone help please...
I have a merged copybook file i.e. 2 copybooks merged to form a single copybook. I have created source and a mapping which has the VSAM source and a Normalizer followed by logic..
For example the copybook has following fields A,B,C
The datafile contains data for...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.