Search results for query: *

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...

Does any one have the Time Dimension table structure, with attributes such as HH,MM,SS,AM/PM,Which_Part_OF_DAY etc..

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')...

Thanks..Thats what i assumed, wanted to be sure...

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...