Interested to Buy Any Domain ? << Click Here >> for more details...
what r the propertes of workflow? and write quary to select
dept more ten employess in dept.?
- 2 Answers
- 6346 Views
- I also Faced
- E-Mail Answers
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 |
why we use stored procedure transformation?
How is Data Models Used in Practice?
In CSV flat file date are in the following format. dd/mm/yyyy (05/01/2005)and d/m/yyyy (5/1/2005) and dd/m/yyyy (05/1/2005) and d/mm/yyyy (5/01/2005). It should be load to target in a unique format. How will you implement this?
we have 6 records in source , i need 2nd record in one target and 5th record in one target or 2nd & 5th record in same target.
What is exclusive and normal mode for repository services?
write sql query following table pname description lux soap sunsilk shampoo lux shampoo sunsilk soap clouseup soap closeup paste i want the output like pname description lux soap sunsilk shampoo lux soap sunsilk shampoo closeup paste closeup paste
Can i create a lookup table without cache.
What will happen if we have a filter transformation used in a mapping and in the filter condition we specify 1. Yes nothing else, only the number 1. In other words, assuming we have 10 rows coming to this filter transformation as an input, how many rows will be output by this transformation when we have only 1 in the filter condition?
I've a denormalized table EMP(empno,ename,phone,addr1,addr2,fax,email). Now I want to insert the record into target in the format that, there will be 2 target rows for 1 source record. In target the row needs to be inserted as: ROW1: empno,ename,addr1,phone ROW2: empno,ename,addr2,fax,email And I'm not allowed to normalize transformation. How to achieve?
hi all, I have to do Informatica Certification? Can any body send me Some Informatica Certification Dumps/FAQS ? Advance Thanks... Send me----: raghukrams@yahoo.com
Using Expression transformation how to remove duplicate records from a relational source?
Hi All, i have question regarding Change Data Capture in Informatica. As i know we can do this using Incremental Aggregation(i never worked on Informatica but i read) and i think we can do the same with SQL Over write and with variables. Can someone tell me how do we do this using other two techniques.. using SQL Over write and variables. Thanks for the help and greatly appreciated.
Teradata 
