![]() Source Qualifier – use shortcuts, extract only the necessary data, limit read of columns and rows on source. ![]() IS IT POSSIBLE TO UPDATE A TARGET TABLE WITHOUT ANY KEY COLUMN IN TARGET? HOW CAN WE IMPLEMENT REVERSE PIVOTING USING INFORMATICA TRANSFORMATIONS?ġ5. CAN WE HAVE AN INFORMATICA MAPPING WITH TWO PIPELINES, WHERE ONE FLOW IS HAVING A TRANSACTION CONTROL WHAT ARE SHORTCUTS? WHERE IT CAN BE USED? WHAT ARE THE ADVANTAGES?ġ3. SESSION WHICH VALUE INFORMATICA WILL READ?ġ2. VARIABLE V1 HAS VALUES SET AS 5 IN DESIGNER (DEFAULT), 10 IN PARAMETER FILE, AND 15 IN REPOSITORY. DESCRIBE VARIOUS STEPS FOR LOADING REJECT FILE?ġ1. WHY TARGET DATABASE CAN REJECT A RECORD?ġ0. WHY INFORMATICA WRITER THREAD MAY REJECT A RECORD?ĩ. OUT OF 100000 SOURCE ROWS SOME ROWS GET DISCARD AT TARGET, HOW WILL YOU TRACE THEM AND WHERE IT GETS LOADED?Ĩ. WHAT DOES FIRST COLUMN OF BAD FILE (REJECTED ROWS) INDICATES?Ħ. WHAT ARE THE DEFAULT VALUES FOR VARIABLES?ĥ. WHAT ARE MAPPING PARAMETERS AND VARIABLES?Ĥ.
0 Comments
Leave a Reply. |