Is load data work "dl_u_assigment" Table ?

[SD_Chandan]

Hi Community,

When i am creating manual record in dl_u_assignment table it is properly setting fields but when i load my data it is not working properly can you anyone help me in properly Loading data in table or any small suggestion is appreciated.

Thanks in advance ...! 

[Ankur Bawiskar · Accepted solution]

@SD_Chandan 
is data getting inserted into staging table?

if yes then transformation should kick off.

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Bhuvan]

@SD_Chandan 

Can you share the steps you followed for automated load ?

It is possible the matcher table entries do not exist and you are trying to create one during data load or it could be due to incorrect usage of matcher field/setter field configuration.

Matcher field is not of type choice to create run time if it do not exist. System expects it to be available before you create data lookup definitions.

If you need more help, please share details of your configuration and where you are facing the issue.

If this helped to answer your query, please mark it helpful & accept the solution.

Thanks,

Bhuvan

[SD_Chandan]

Hi @Bhuvan  ,

We created field's first and then doing data load is these correct way or now ?

[Bhuvan · Accepted solution]

@SD_Chandan 

Can you check the choice fields are available and you are using actual value and not the label ?

I tried this in my PDI and it works fine. 

In the choice action, use ignore so that it does not create new option in the sys_choice table. If you use choice create [default], it does not work and it expects the script to handle the creation.

If this helped to answer your query, please mark it helpful & accept the solution. 

Thanks,

Bhuvan

[Bhuvan]

@SD_Chandan 

Did you get a chance to review this as I believe the information provided should answer your question

If my response helped to guide you or answer your query, please mark it helpful & accept the solution.

Thanks,

Bhuvan