DSXchange

Hi,

Can we call UniX Scripts in Jobs? i.e Transformer Stage

if IsNull(A) then SetNull()

Instead of the above condition can we use

NullToValue(A,NULL).

Please suggest me.

1$244$^@$$$
Where $ is Delimiter.
but ^@ generating extra.
I beleive this is due to Empty STring.

Hi,

We are generating the Files

when we generate the file getting (^@) i.e Null Character(Char(0)).
Due to this we are unable to load the file.

Is Mapstage is called as Datastage TX Job in Parallel Job processing Stage.

Unfortunately we lost all jobs.We dont have backup
But we have exe jobs.

How do i convert into Exe into Design.
is there any way to do that?

the thing i have used existing as reference and New as source.
In reference i dont have any records.
so we populating the records first time.
how do i insert the records with rec version.

Im using LookupStage .im getting below message.

I got the massege: Failed a keylookup for record. Then it gives another msg: Operator's runLocally() failed.

i don't know where to change the Failed to Continue.

http://etl-tools.info/en/datastage-tuto ... astage.htm


Im not able to insert new records when we load first time.
How to insert the record version for first time load

For next time i can upto into REC_VERSION+1

Hi,

Design is

SOurce-------lookup------transformer-------transformerSplit----insert and update.

I have insert the rec version when we load first time.

Hi,

I have exactly the same design.

When we load the records first time into the dimension table.
How can i load without Suurogate key stage,trigger.

Please advice me

exactly the same design in ETL Tools Info.

etl-tools.info - datastage-tutorial- scd2-implementation

Hi,

I have exactly the same design.

When we load the records first time into the dimension table.
How can i load without Suurogate key stage,trigger.

Hi,

source-------lookup--------transformer-------Insert and Update

When we load the record into the dimension table first time.
How can i load record version without Surrogate key,trigger and sequence options.

From Clause missed.
What is the datatypes for those two columns.

laknar

Hi all,

I have acheived this through UNION ALL.

Laknar

Check for length in transformer stage if it is 0 then use set null function.