Hii, Why can't we use concurrent workflow with different par files instead of creating 21 sessions, then its very easy process right? I'm just thinking what if Interviewer asks this question. Anyone please correct if I am wrong?
Hi, can you pls explain how you are going to update the parameter file to latest sysdate after 1st run?Is it through shell script or separate mapping(using exp)?I've used in a separate mapping using expression iif(substr (FIELD1,1,9)='$$LOAD_DT','$$LOAD_DT='||TO_CHAR(SYSDATE,'MM/DD/yyyy hh24:mi:ss') , FIELD1). Also, since it is a flat file parameter file, so I've created a batch file after post session success command to move previous dyn_parameter file to old folder,delete itand then rename the updated dyn_parameter file as current dyn_parameter_file.txt. @echo off move C:\Informatica\9.6.1\server\infa_shared\Params\dyn_parameter_file.txt C:\Informatica\9.6.1\server\infa_shared\Params\OLD\dyn_parameter_file.txt del C:\Informatica\9.6.1\server\infa_shared\Params\OLD\dyn_parameter_file.txt rename C:\Informatica\9.6.1\server\infa_shared\Params\updt_dyn_param.txt dyn_parameter_file.txt kindly, let me know if there is any more effective method to update the parameter file after 1st run?
could you please let me know how you have generated the parameter file from job_control table? As in one of your videos, we've seen parameter file updating the job_control table.
The kind of explanation you are giving for this complex mapping scenario makes the scenario so simple :)
You can pull data from audit tables directly right instead of parameter files..
Very detailed explanation,can i get the mapings xml ,wf .xml...Interested to see.
Hii, Why can't we use concurrent workflow with different par files instead of creating 21 sessions, then its very easy process right? I'm just thinking what if Interviewer asks this question. Anyone please correct if I am wrong?
Hi, can you pls explain how you are going to update the parameter file to latest sysdate after 1st run?Is it through shell script or separate mapping(using exp)?I've used in a separate mapping using expression
iif(substr (FIELD1,1,9)='$$LOAD_DT','$$LOAD_DT='||TO_CHAR(SYSDATE,'MM/DD/yyyy hh24:mi:ss') , FIELD1).
Also, since it is a flat file parameter file, so I've created a batch file after post session success command
to move previous dyn_parameter file to old folder,delete itand then rename the updated dyn_parameter file as current dyn_parameter_file.txt.
@echo off
move C:\Informatica\9.6.1\server\infa_shared\Params\dyn_parameter_file.txt C:\Informatica\9.6.1\server\infa_shared\Params\OLD\dyn_parameter_file.txt
del C:\Informatica\9.6.1\server\infa_shared\Params\OLD\dyn_parameter_file.txt
rename C:\Informatica\9.6.1\server\infa_shared\Params\updt_dyn_param.txt dyn_parameter_file.txt
kindly, let me know if there is any more effective method to update the parameter file after 1st run?
can you please let me know how you have generated the parameter file using mapping parameters.If you have any class on that please let me know.
can you send me your email id and mobile number
rahulparasam@hotmail.com and 8374384623, please send me as well
@@TEKCLASSES hi i have the same query in this mapping could you please help
Hiii
Can i get informatica scenario
Document ......
Hi..you have mentioned Normalizer transformation used for creating parameter file..can any one explain that?
Yes please explain that
we can create one session with variables and can pass those values in scheduling tool, please correct me if I am wrong
even I have the same query. why 21 sessions
could you please let me know how you have generated the parameter file from job_control table? As in one of your videos, we've seen parameter file updating the job_control table.
Did you get the answer on this?
Did you get the answer for this ?
Thank you so much
Voice is exactly like my onsite counterpart