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 |
When you connect to repository for the first time it asks you for user name & password of repository and database both. But subsequent times it asks only repository password. Why?
server hot-ws270 is connect to Repository B. What does it mean?
What is the exact difference b/w IN and EXIST in Oracle..?
Differentiate between joiner and lookup transformation?
wt is informatica file watch timers in aflat i want to get the first record and last record how could i.
How do you load only null records into target? Explain through mapping flow.
i have a wf like wf-->s1-->s2-->s3-->s4 first start s1 later s2 later s3 here my session s3 have to run 3 times later start s4?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
How to implement security measures using repository manager?
when will we go for unconnected lookup transformation in Informatica?
Can anyone give some input on "Additional Concurrent Pipelines for Lookup Cache Creation" ? I know that this property is used to build caches in a mapping concurently. But which values should I set into this ( i.e. 1 or 2 or 3 or something else ) for concurrent cache building ?
How do you avoid duplicate records with out using source qualifier,expression,aggrigator,sorter and lookup transformations ?