DSXchange

Hi,

Use the below function to get all the characters before the first "_" in a column
Field(Column_Name,"_",1)
It might work.

______________________________________________________
Sreeni

Hi,

Single "_" or might chance multiple"_" s occurs in the string?

_____________________________________________________
Sreeni

Hi,
1)ensure metadata is same?If Yes,use sequential file stage:File pattern option to import multiple files.specify the value is HFDC_*.csv
It will work.

-----Sreeni

Give more clarity.
----Sreeni

Sort the records and take a constraint as inrownum=1.It might work.

--------sreeni

Yes. By using Execute Command stage and Terminator stages in a Sequence.

Hi,

Need to run any script?Or use external filter/seq file options?Please give clarity regarding this.Where should we write sed command to resolve this?

Thanks in advance
Sreeni

Hi ArndW,

Thanks for the reply.

---Sreeni

Hi Experts,

I didn't use Command Line sofar.What is the Command Line?Where should we find out?

Thanks in advance,
sreeni

Hi experts,

I have 10 textfiles.Each File has a Column_Total in its Trailer.Different columns are used to calculate for Column_Total in every file.How can we check the Column_Total in Datastage by a common job for all text files.

can anyone suggest regarding this?

Thanks in Advance,
sri

Hi, Thanks for the reply.I tried with the below derivation. If Trim(NullToValue(Column_A,'')) <> '' Then Trim(Column_A) Else NullToValue(Column_A,'') But all records got rejected by Oracle Stage.I checked metadata also. I am not getting any idea to solve the above issue. Thanks in Advance, Sreeni

Hi Experts, In my job we are capturing changes in the Current file against an Empty file. Here all the records are new records and i am populating these records to Oracle Table.All the records are inserted into Oracle table. Now,We are using a new current file against the Empty file to captures the ...

Hi, I am getting below warning when i am using the Change Capture stage. "Change_Capture: When checking operator: Defaulting "Column_Name" in transfer from "beforeRec" to "outputRec". What is the reason for it? Please anybody help me to resolve it. Thanks in advanc...

Hi,

I am facing the problem with sqlcode="-1" while updating the records with upsert mode in Oracle stage.

Please help me to reslove this issue.

Thanks in advance,
Sreeni