what r the propertes of workflow? and write quary to select
dept more ten employess in dept.?
Answers were Sorted based on User's Feedback
Answer / srikanth
select count (*), deptno from emp group by deptno having
count(*)>10;
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / guest
1.Work flow is used to start up the session on Informatica
server.
2.It is used to schedule the session on Informatica server
at specified date and time.
select * from emp where deptno=(
Is This Answer Correct ? | 1 Yes | 1 No |
There are 3 groups in router transformation in which there are no conditions mentioned, so what happens if I connect these groups to the 3 targets? How many records gets into each target.(suppose if we are getting 10 records from the source)
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.
Make a note of the quantity vaults made in informatica?
How to find from a source which has 10,000 records, find the average between 500th to 600th record?
what is the architecture of any Data warehousing project?
What is the Rank index port in Rank transformation?
What is a configuration management?
If I have a index defined on target table and if set it to bulk load will it work ?
Write the program through which the records can be updated?
what type of documents you receiving from client later wt can you do? what type of documents have to prepare?
how to read data from website into informatica? plsss send answers ASAP thanks in advance.
what is normalization? explain 1st NF, 2nd NF, 3rd NF