Answer / swetha

Yes.By setting the option always runs the session.

Answer / janardhanreddy

$Session.Status=Succeed or $Session.Status=fail

Answer / bsgsr

hi,
swetha,

i am impressed with your answers and your curiousity or
zeal or interest in posting answers to the questions.
infact, i am trying for a break with the industry. i am
bsgsr infact u might have seen my name the way i did see
yours while surfing this site.

i am of the opinion that kt can certainly help in enriching
ones knowledge. i am intersted in sharing. if you too do
mail me on bsgsr12@gmail.com.

anticipating a positive response.

Why we use lookup transformations?

1 Answers  

---

i have source data like id name sal 1 a 65020 2 b 78250 3 c 58264 but how to get target like this id name sal 1 a Sixty five thousand twenty 2 b Seventy thousand two fify 3 c Fifty eight thousand two sixty four

3 Answers  

---

Do you find any difficulty while working with flat files as source and target?

0 Answers  

---

a flat file having 1 laks records. if i want convert excel file what happen. (bcz a exccel sheet having 65536 colums but flat files one lak columns). how to get one laks colums in excel sheet .

2 Answers   TCS,

---

Consider a Phone Log table as below. It records all phone numbers that we dial in a given day. SOURCE_PHONE_NUMBER DESTINATION_PHONE_NUMBER CALL_START_DATETIME 1234 4567 01/07/2011 10:00 1234 2345 01/07/2011 11:00 1234 3456 01/07/2011 12:00 1234 3456 01/07/2011 13:00 1234 4567 01/07/2011 15:00 1222 7890 01/07/2011 10:00 1222 7680 01/07/2011 12:00 1222 2345 01/07/2011 13:00 Please provide an SQL query to display the source_phone_number and a flag where the flag needs to be set to Y if first called number and last called number are the same and N if the first called number and last called number are different. Desired Output: Source Number Is_Match 1222 N 1234 Y

2 Answers   Amazon,

---

wht is cdc?how to use it in creation of mappings?

6 Answers   HSBC,

---

How do u identify or filter out a 0 byte file available in a folder by using UNIX command?

1 Answers   Wipro,

---

Hi frndz, "while i am going to run the infotmatica power designer,he ask the id and password ",then i enterd the id and passwd , at that time i got the error as " failed to connect repository " ?

3 Answers  

---

There are 4 flat files with number of records as indicated below. Which files should be picked first for joining using joiners so as to get best performance. File A - 1000 records File B - 100 records File c - 10000 records File D - 10 records Please explain. Thanks and Regards,

1 Answers   Amdocs,

---

3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

0 Answers   TCS,

---

i have different sources in different databases ,that sources may be 100 tables i want to load these tables in to single target how to pearform the task

14 Answers   Altisource, TCS,

---

What are the mapping parameters and mapping variables?

0 Answers   Informatica,

---