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

While using update strategy in the mapping which gives more performance, a flat file or Table? Why? What are the advantages and disadvantages?

4 Answers  

---

there is a product table prodid prodname price 100 cinthol 10 101 hamam 10 102 neem 20 103 cake 30 in the above table the price of some products are duplicated and some product prices are distinct we want to push the duplicated prices to one target and non-duplicated prices to other target without using expression and sequence generator transformation

3 Answers  

---

r u done any partitions in ur project?

0 Answers   TCS,

---

what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not

0 Answers  

---

What is transformation?

0 Answers  

---

---

how to remove staging area

1 Answers  

---

If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

0 Answers   IBM, TCS,

---

What is the need of building a data warehouse?

2 Answers  

---

select count(1) from emp? what is the o/p?

5 Answers   TCS,

---

What is the difference between procedure and stored procedur?

2 Answers   IBM,

---

What are Rapid changing dimensions?

1 Answers  

---

sorce is a flatfile only 1st and last row should insert to target how will u do?

2 Answers   HCL,

---