what r the propertes of workflow? and write quary to select dept more ten emplo

what r the propertes of workflow? and write quary to select
dept more ten employess in dept.?

Question Posted / r.v

2 Answers
6282 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

what r the propertes of workflow? and write quary to select dept more ten employess in dept.?..

Answer / srikanth

select count (*), deptno from emp group by deptno having
count(*)>10;

Is This Answer Correct ?

2 Yes

0 No

what r the propertes of workflow? and write quary to select dept more ten employess in dept.?..

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

Post New Answer

More Informatica Interview Questions

i have a source table ID NAME SAL 101 A 1000 102 B 2000 103 C 1500 target load should be ID NAME SAL 101 A 1000 101 B 2000 101 C 1500 102 A 1000 102 B 2000 102 C 1500 103 A 1000 103 B 2000 103 C 1500

3 Answers TCS,

What is an incremental loading? in which situations we will use incremental loading

2 Answers HCL,

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

0 Answers

What is different between the data warehouse and data mart?

0 Answers

How can we use batches?

0 Answers

Using Informatica Visio to generate mappings. I am getting error "Table Definition Not Found Exception Error" while importing the template.

1 Answers

What is aggregate awareness?

1 Answers

how can u connect client to ur informatica sever iff server is located at different place( not local to the client)

3 Answers Accenture,

Please let me know how to do estimation before staring development in project. Here estimation in the sense how many associates are required, etc to complete the project.

1 Answers iGate,

How do you recover rows from a failed session

1 Answers

How to convert flat file into xml file? How to tune joiner?

2 Answers Accenture,

How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how

0 Answers CTS,

For more Informatica Interview Questions Click Here