How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
No Answer is Posted For this Question
Be the First to Post Answer
Why we need XMLs?
Why can't we connect 2 active transformations to an active transformation ? Ex:- One aggriagator and one sq trans to an router transformation
pmscmd startworkflow -sv <host name> -d <domain name> -u <user name> -p <password> -f <folder name> <workflow name> while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?
Q. WE ARE LOADING ORACLE TABLE THE PROCESS RUNS THREE HOURS. THIS TABLE IS BEING USED BY SOME DOWNSTREAM TEAMS SO WHAT WE WANT IS IN BETWEEN RUN IS PROGRESS IF ANYONE IS FETCHING THE DATA FROM THE TABLE THEY SHOULD SEE DATA TILL YESTERDAY TILL THAT. AFTER THAT PROCESS IS COMPLETED ONLY THEN TEAM SHULD BE AVAIBLE TO SEE TODAY DATA UPDATED. WE DONOT WANT TO LOG THE TABLE. NEED APROACH FROM YOUR SIDE.
Whatis the difference between View and Materialized View ?
How do you load unique records into one target table and duplicate records into a different target table?
A TABLE CONTAINS SOME NULL VALUES . HOW TO GET (NOT APPLICABLE(NA)) IN PLACE OF THAT NULL VALUE IN TARGET .?
What is operational data source (ODS)?
Explain direct and indirect flat file loading (source file type) - informatica
Hi, In Router transformation I created two groups . One is Passthrough=> True Second one is CorrectId’s => Invest>50000 Here I have one doubt. Can’t I treat default group as Passthrough group (fist group) . Is there any difference between default group and Passthrough group in this scenario? Let me know if you want more information about this scenario. Advance thanks.
I have name like INDIA in a column. I want display 1st line A, 2nd line N, 3rd line D, 4th line I, 5th line A in oracle data base?
version controlling in informatica?