How to dynamically create target files based on input conditions using Transaction Control ?

Поділитися
Вставка
  • Опубліковано 30 січ 2025

КОМЕНТАРІ • 14

  • @vamshidharv7
    @vamshidharv7 2 роки тому

    Thank you so much !! It was really helpful.

  • @naveenavnp383
    @naveenavnp383 Місяць тому

    i am facing mapping error "Target definition has more than one Transaction Control point connected to it" pls help

  • @harshaas_diary
    @harshaas_diary 4 місяці тому

    I tried to create files in unix shared path and it worked, but the file doesn't have write access (chmod 777). How to provide chmod 777 to the files that are created dynamically. I know that we can pass the command in post session success command but these dynamically created files are taking name from mapping, how should we mention it?

  • @soumyavusikarla413
    @soumyavusikarla413 3 роки тому +1

    Hi, I have a scenario like there is one source flat file and target is 3 tables/flat files..so first time all the data should go to table1 and in 2nd run all the data should go to table 2 and in 3 Rd run all the data should go to table 3 and same process has to be repeated ..could you please help me with the solution

  • @amitojsahni939
    @amitojsahni939 Рік тому

    Hi,I have tried this scenario but i can only see one out file in target file folder .Other 3 csv files are not getting generated dynamically. Can you please help me what could be the reason for that.

  • @sowmyagayatrichelluboyina2561
    @sowmyagayatrichelluboyina2561 3 роки тому

    How to proceed if we have a situation like according to the number of input files the target files should be created?

  • @sreenadhchanti3741
    @sreenadhchanti3741 2 роки тому

    Hi,I have created the mapping as you explained and i got the output as expected. I have a doubt we got the output in csv format.is there is any possibility to create the output in tables.

  • @vidyasagar6924
    @vidyasagar6924 2 роки тому

    Hi, In the same way can we create tables in DB dynamically on the fly..?

  • @viveksingh-oh8xi
    @viveksingh-oh8xi 3 роки тому

    Hi, I have created the mapping as you explained in your videos but in my scenario only one csv file generated with admin department and all the records in it. could you please let me know what could be the reason..??

    • @PranoyGuha
      @PranoyGuha 3 роки тому

      Are you mapping the columns as mentioned in the video ?
      In the expression box, the FLAG field must lie between the CURR_VALUE and PREV_VALUE fields.

  • @kavitha4384
    @kavitha4384 11 місяців тому

    Thanks

  • @JC_Magi
    @JC_Magi 6 місяців тому

    Thanks