Answer / kondeti.srinivas

if source or target or wf or mappings are checked in state
we can not delete or update those. those can be modified by
user which is originally created by using cheked out.
if created user checked out,he can only can cheked out.
this nothing but a version control...

Answer / praveen.hattikal

Check out & check in are users locks over WF/Session/source
or target .A user has to checkOut a object for any
modification. If the object is checked in it cant be
modified.any changes done by checking out will reflect on
server only ofter checking in...we can run a wf at any
state irrespective of whether it is checked in or out

Answer / devaraj

before executing workflow the workflow need to be checked-
in, if it,s checked-out it will get fails need to checked-
in re run the workflow

How to find from a source which has 10,000 records, find the average between 500th to 600th record?

3 Answers  

---

If we can implement SCD TYPE 1 AND 2 IN A SINGLE MAPPING.. CAN WE SEE THE RESULT IN A SINGLE OUTPUT? I MEAN I WANT THE RELSULT OF BOTH SCD 1 AND 2 TO BE SEEN IN A SINGLE RUN?

1 Answers   TCS,

---

In update strategy target table or flat file which gives more performance ? why?

7 Answers  

---

Hi, As shown below i have repositories under that some folder are there . Between these repositories and folder some thing is there.I want to know what is that? repositories repo1 repo2 repo3 IS_## IS_## IS_## Folder1 Folder2 Folder3 - - - Here i want to what IS_## represents ? Advance Thanks

1 Answers   IBM,

---

how to get the data from the client machine and how to get server location data to client loction can any one explain bit deep please..!

3 Answers   TCS,

---

---

What is the use of incremental aggregation?

2 Answers  

---

Data transformed successfully from Source table to target table. Now how you will ensure that the data in Target table is proper. I answered will verify one or two records and check Then question was that the Development is doing (1-2 record verification)but as a tester you have to verify the complete data, how you will do?? Please answer

2 Answers  

---

What is the default join that source qualifier provides?

3 Answers   Informatica,

---

I have a scenario with lookup table. in that lookup table have colomns, but i need to process only 10 colomns out of 50. Please te me how can we acheive it?

6 Answers   TCS,

---

Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

0 Answers  

---

to improve the performance of aggregator we use sorted input option and use sorter t/r befor aggregator. But here we are increasing one more cache in our mapping i.e; sorter. So how can u convince that you are increasing the performance.?

3 Answers   IBM,

---

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,

---