Informatica Complex Mapping Implementation | Informatica Interview Questions

Oracle 11g Online training at TekClasses.com gives the in-depth knowledge on real-time work experience. Oracle Database is also be defined as RDBMS, it's an Object-relational data base management system which developed by Oracle Corporation. Oracle 11g is the latest and most refined database system. It enables sophisticated applications, high-speed transactions and higher business selections. Information will be accessed through SQL from the database and Oracle is not any exception. PL/SQL is the procedural language extension to the SQL. There is no other way to access the information from within the program and the SQL is often embedded in PL/SQL programs. tekclasses.com

[@meenumol8313]

The kind of explanation you are giving for this complex mapping scenario makes the scenario so simple :)

[@kiranv6537]

You can pull data from audit tables directly right instead of parameter files..

[@SunilMoharana1989]

Very detailed explanation,can i get the mapings xml ,wf .xml...Interested to see.

[@ramuurs7227]

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?

[@ShaluChaudhary]

Thank you so much

[@debosreesinha4569]

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?

[@sahithigelli9067]

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.

[@TEKCLASSES]

can you send me your email id and mobile number

[@TheRahulguptha]

[e-mail] and 8374384623, please send me as well

[@ajaykumarpati1233]

@@TEKCLASSES hi i have the same query in this mapping could you please help

[@Kk-yn7dk]

we can create one session with variables and can pass those values in scheduling tool, please correct me if I am wrong

[@ankushpatil1114]

even I have the same query. why 21 sessions

[@pathinageswararo16]

Hiii
Can i get informatica scenario
Document ......

[@punyas9360]

Hi..you have mentioned Normalizer transformation used for creating parameter file..can any one explain that?

[@Telugu_Cinetalks]

Yes please explain that

[@rahultiwari9374]

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.

[@ajaykumarpati1233]

Did you get the answer on this?

[@VenkatReddy-zo3kx]

Did you get the answer for this ?

[@harishkumarv6100]

Voice is exactly like my onsite counterpart