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 |
Can we use the mapping parameters or variables created in one mapping into another mapping?
Flat file heaving 1 lack records and I want to push 52000 records to the target?
What do you mean incremental aggregation?
how many tasks are there in informatica ?
15 Answers DELL, iGate, TCS,
Name at least 5 different types of transformations used in mapping design and state the use of each.?
for ex: in source 10 records are there with column sal. use a filter transformation condition as Sal=TRUE and connect to target. what will happen.
In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?
How to generate or load values in to the target table based on a column value using informatica etl tool.
Input is like 1 1 1 2 2 3 and out put should be 1 2 3 How can u acheive using rank transformation ??
In my sourse i have like ename,gender vasu,male geetha,female ram,male suma.female kesav,male in my output i need male,female vasu,geetha ram,suma kesav
when will we go for unconnected lookup transformation in Informatica?
Hi, This is Ranadheer. How to load fact tables using dimeension tables. Please anyone give me a answer with example. Thanks in Advance.