Hi All,
I have created a sequence and my sequence number should not restart with 1 after reaching the maximum value.After reaching the maximum value 100 it should give error.Please reply to this query
please find below the code :
CREATE SEQUENCE pos AS INTEGER START WITH 1 INCREMENT
BY 1...
appreciate if anybody can help me with the row to column conversion. Like for exampleIn a single row I have something like this.
TABLE SOURCEE
EMPID-------------SAL
101 3000
101 4000
101 4200
101 5000
102 3200
102 3800
102 4200
102 4800
103 3100
103 3700
103 4300
....
AND I WANT LIKE THIS...
appreciate if anybody can help me with the row to column conversion. Like for exampleIn a single row I have something like this.
TABLE SOURCEE
EMPID-------------SAL
101 3000
101 4000
101 4200
101 5000
102 3200
102 3800
102 4200
102 4800
103 3100
103 3700
103 4300
....
AND I WANT LIKE THIS...
am totally new to unix environment it would be great if any body can suggest me
a good link to learn how informatica sessions,batches can be created by writing
shell scripts and anything w.r.t to unix that will be useful to work with informatica.
thanks in advance for your help !!
how unix/korn shell scripts r helpful for ETL,
Can u give me any one or two examples.for what do we use shell scrpting ?any any one give code .
I appreciate u if u respond immediately,
bcz it is very urgent for me.
Hi All,
Can you please tell me how to tackle with sessions ,that are running more than 1 day . I submitted few sessions they r taking lot of time . can you please reply me on this issue . and how to improve the session performance ???.
thank you !
Thanks for the reply . Ok both are multi dimensional structures . then my question is why to go for cubes then ?. only impromptu report is enough then .Please clarify this doubt .
thanks .
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.