what r the propertes of workflow? and write quary to select
dept more ten employess in dept.?
Answer Posted / srikanth
select count (*), deptno from emp group by deptno having
count(*)>10;
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
Slowly changing dimensions, types and where will you use them
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
What are mapplets?
How can a transformation be made reusable?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
What is a connected transformation?
How to load the data from a flat file into the target where the source flat file name changes daily?
How can you differentiate between powercenter and power map?
What is an unconnected transformation?
In development project what is the process to follow for an etl developer from day1
Explain how to import oracle sequence into informatica?
Design a mapping to load the cumulative sum of salaries of employees into target table?
What are the types of lookup transformation?
I have a flat file, want to reverse the contents of the flat file