Answer / thippareddy.p

if (drawtime)< 13 then drawtime=drawtime+12 else drawtime

Answer / subbuchamala

SRC--->Transformer--->TGT

In the TFM Output Columns Derivations:


(HoursFromTime((MyLnk.drawtime:"00"))+12): MinutesFromTime(MyLnk.drawtime)--->OutputColumn

(MyLnk.drawtime:"00")--->Convert Source Format to %hh:%nn:%ss
(HoursFromTime((MyLnk.drawtime:"00"))+12)--->Adding 12 hours to hours from source and Concatanating with Minutes from Source.

Display all files which have size more 3KB in given directory/folder.

1 Answers   TCS,

---

1)What is ur project architecture ? 2)how to move project from developement to uat? 3)What is the difference between datastage 6,7.1 and datasttage 7.5? 4).How to do error handling in datastage? 5)3.Whta is unit testing, system testing and integration testing? 6)What is the Exact difference between BASIC Transformer and NORMAL Transformer?When we will go for BASIC Or NORMAL Transformer 7)why we use third party tools in datastage? 8)What is the purpose of Debugging stages? In real time Where we will use?

6 Answers   CTS, HCL, IBM, Wipro,

---

how to remove duplicates in transformer stage by using stage variables?one example?

6 Answers   Syntel, TCS,

---

What is the difference between an operational datastage and a data warehouse?

0 Answers  

---

i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu

0 Answers  

---

A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?

0 Answers  

---

if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables?chandu how can i implement scd typ1 and type2 in both server and in parallel?chandu field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the ,inthe fields?

2 Answers  

---

why do u need the IOS upgradation in a FC switch

0 Answers   IBM,

---

3) Sequential file contains data like Empno ename sal 111 abc 2000 Trgt file: Trgt1----111 Trgt2----abc Trgt3---2000

2 Answers  

---

Can we use Round Robin for aggregator?is there any benefit underlying?

3 Answers   TCS,

---

where the log files or tables can store in DS?

2 Answers   IBM,

---

How much data u can get every day? 2)which data ur project contains? 3) what is the source in ur project?what is the biggest table & size in ur schema or in ur project?

2 Answers   Wipro,

---