Answer / prasad

The function appears like this IIF(IS_DATE(DATE, 'DD-MON-YY'),TRUE,FALSE)

Answer / gyana

u can use the TODATE() function to make it as default date
and time

wht target override?wht advantages it has compare to target update?

2 Answers   Polaris,

---

Session S1, S2, and S3. In the session S3 I want to load every Saturday. How it is possible?

2 Answers   TCS,

---

what is flat file override?

1 Answers   Cap Gemini, HP,

---

My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? means only one source qualifier has 2 columns like empno, sal. connected to same target as shown in above mapping.Is this mapping valid or any issues are there if we design like this?

2 Answers   Span Systems,

---

what is data driven?

5 Answers   TCS, Wipro,

---

what is the size of ur database(like oracle)

2 Answers   HP,

---

What happens when a session fails and you click on recover?

0 Answers  

---

source table have single column single record having with single space. load that source record into trg . trgt having two columns and the SOURCE TABLE LIKE COL1 BHANU PRASAD TRGT TABLE COL1 COL2 IN THAT LOAD THE RECORD IN THE trgt table LIKE COL1 COL2 BHANU PRASAD HOW ? TELL ME PLZ

2 Answers   Wipro,

---

If I have a index defined on target table and if set it to bulk load will it work ?

4 Answers   IBM,

---

How do you load unique records into one target table and duplicate records into a different target table?

0 Answers  

---

i have source flat file like 1 a,1 b,1 c,2 a,2 b,2 c i want output as 1 a,b,c and 2 a,b,c ... how can achieve this

5 Answers   TCS,

---

PLS REAL TIMERS IAM WAITING FOR FAVOROBLE REPLY..REGARDING ETL TESTING INFORMATION...ETL TESTER NEEDS ETL DEVOLPMENT KNOWLEDGE OR NOT..?. IF HE NEED DEVLPMNT KNOW WHAT HE LEANR FIRST... AS A DEVOLOPER U KNOW THE ETL TESTING PROCESS.. PLS EXPLAIN IN DETAIL THANK U

2 Answers  

---